package com.cnhis.cloudhealth.clinical.osworks.commonsql.dao;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

import com.cnhis.cloudhealth.commons.dao.BaseDao;

@Repository
public class OsHooperDao extends BaseDao{

	/*@SuppressWarnings("rawtypes")
	public int updateVAT1(List tmpVAT1) {
		if(tmpVAT1.size() > 0){
			Map<String , Object> map = new HashMap<String , Object>();
			map.put("list", tmpVAT1);
			return getSqlSession().update("OsHooper.updateVAT1", map);
		}else{
			return 0;
		}
		
	}*/

	@SuppressWarnings("rawtypes")
	public String getBEE03(Map map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.getBEE03", map);
	}

	public int updateVAT1(@SuppressWarnings("rawtypes") Map map) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateVAT1", map);
	}

	public int updateBEE1(int BEE01) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateBEE1", BEE01);
	}

/*	@SuppressWarnings("rawtypes")
	public int getCount(Map map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.getCount", map);
	}*/

	@SuppressWarnings("rawtypes")
	public void insertTmpVAX1TmpBCE11(Map map) {
		getSqlSession().insert("OsHooper.insertTmpVAX1TmpBCE11", map);
		
	}

	@SuppressWarnings("rawtypes")
	public void insertTmpVAX1TmpBCE1(Map map) {
		getSqlSession().insert("OsHooper.insertTmpVAX1TmpBCE1", map);
		
	}
	
	@SuppressWarnings("rawtypes")
	public void insertTmpVAX1TmpBCE2(Map map) {
		getSqlSession().insert("OsHooper.insertTmpVAX1TmpBCE2", map);
		
	}

	@SuppressWarnings("rawtypes")
	public void insertTmpVAX1TmpBCE3(Map map) {
		getSqlSession().insert("OsHooper.insertTmpVAX1TmpBCE3", map);
	}
	
	@SuppressWarnings("rawtypes")
	public void createTmpVAX1(Map map) {
		getSqlSession().insert("OsHooper.createTmpVAX1", map);
		
	}

	@SuppressWarnings("rawtypes")
	public void deleteVAX1(Map map) {
		getSqlSession().delete("OsHooper.deleteVAX1", map);
		
	}

	@SuppressWarnings("rawtypes")
	public List selectTmpVAX1Count() {
		// TODO Auto-generated method stub
		return getSqlSession().selectList("OsHooper.selectTmpVAX1Count");
	}

	@SuppressWarnings("rawtypes")
	public String selectBCE02(Map map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectBCE02",map);
	}

	public String selectValue() {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectValue");
	}

	@SuppressWarnings("rawtypes")
	public int selectBCE01(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectBCE01",mapList);
	}

	@SuppressWarnings("rawtypes")
	public int insertVAX1(Map map) {
		// TODO Auto-generated method stub
		return getSqlSession().insert("OsHooper.insertVAX1", map);
	}

	@SuppressWarnings("rawtypes")
	public int selectcountVAV11(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectcountVAV11",mapList);
	}

	@SuppressWarnings("rawtypes")
	public String selectVAV011(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectVAV011",mapList);
	}

	@SuppressWarnings("rawtypes")
	public int selectcountVAV12(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectcountVAV12",mapList);
	}

	@SuppressWarnings("rawtypes")
	public String selectVAV012(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectVAV012",mapList);
	}

	public int selectID(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectID",map);
	}

	public int selectValueID(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectValueID",map);
	}

	public void insertCoreSequenceObjects(Map<String, Object> map) {
		// TODO Auto-generated method stub
		getSqlSession().insert("OsHooper.insertCoreSequenceObjects", map);
	}

	@SuppressWarnings("rawtypes")
	public List selectCoreSequencesList(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectList("OsHooper.selectCoreSequencesList",map);
	}

	public void updateCoreSequences(Map<String, Object> map) {
		// TODO Auto-generated method stub
		getSqlSession().update("OsHooper.updateCoreSequences",map);
	}

	public int selectCoreSequencesValue(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().selectOne("OsHooper.selectCoreSequencesValue",map);
	}

	public void insertCoreSequencesValue(Map<String, Object> map) {
		// TODO Auto-generated method stub
		getSqlSession().insert("OsHooper.insertCoreSequencesValue",map);
	}

	@SuppressWarnings("rawtypes")
	public void insertVAV1(Map mapList) {
		getSqlSession().insert("OsHooper.insertVAV1",mapList);		
	}

	@SuppressWarnings("rawtypes")
	public void updateVAV1(Map mapList) {
		// TODO Auto-generated method stub
		getSqlSession().update("OsHooper.updateVAV1",mapList);
	}

	@SuppressWarnings("rawtypes")
	public void insertVAV12(Map mapList) {
		// TODO Auto-generated method stub
		getSqlSession().insert("OsHooper.insertVAV12",mapList);	
	}

	public int updateHOOper833(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateHOOper833",map);
	}

	public int updateHOOper826(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateHOOper826",map);
	}

	@SuppressWarnings("rawtypes")
	public void updateVAV12(Map mapList) {
		// TODO Auto-generated method stub
		getSqlSession().update("OsHooper.updateVAV12",mapList);
	}

	public int updateHOOper826Os(Map<String, Object> map) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateHOOper826Os",map);
	}

	public void updateHOOper833Bee1(Map<String, Object> map) {
		// TODO Auto-generated method stub
		getSqlSession().update("OsHooper.updateHOOper833Bee1",map);
	}

	public int updateVAT1isnullDate(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateVAT1isnullDate", mapList);
	}

	public int updateVAT1isnullBee1(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateVAT1isnullBee1", mapList);
	}

	public int updateVAT1isnullDateBee1(Map mapList) {
		// TODO Auto-generated method stub
		return getSqlSession().update("OsHooper.updateVAT1isnullDateBee1", mapList);
	}

	public void deletetmpVAX1() {
		getSqlSession().delete("OsHooper.deletetmpVAX1");
	}

	public void deleteVAV1(Map mapList) {
		getSqlSession().delete("OsHooper.deleteVAV1",mapList);
	}


}
